<!DOCTYPE html>
<html>
<head lang="en">
    <meta charset="UTF-8">
    <title>前台主页</title>
    <link rel="stylesheet" href="../css/qt/Merry-go-round.css"/>
    <link rel="stylesheet" href="../css/qt/index.css">
    <link rel="stylesheet" href="../css/qt/footer.css">
    <link rel="stylesheet" href="../css/qt/nav.css">
    <link rel="stylesheet" href="../css/qt/head.css">
    <script src="../JS/Merry-go-round.js"></script>
    <script src="../JS/jquery-1.12.4.js"></script>
    <style>
        * {
            padding: 0;
            margin: 0;
            list-style: none;
        }
    </style>
</head>

<body>

<!-- 顶部导航starting -->
<?php
require('../qt/common/nav.php')
?>
<!-- nav ending -->


<!-- 旋转木马轮播starting -->
<div class="wrap" id="wrap">
    <div class="slide" id="slide">
        <ul>
            <li><a href="#"><img src="../images/Carousel/Java1.jpg" width="300" height="300" alt=""/></a></li>
            <li><a href="#"><img src="../images/Carousel/js1.jpg" width="300" height="300" alt=""/></a></li>
            <li><a href="#"><img src="../images/Carousel/HTML1.jpg" width="300" height="300" alt=""/></a></li>
            <li><a href="#"><img src="../images/Carousel/PHP1.jpg" width="300" height="300" alt=""/></a></li>
            <li><a href="#"><img src="../images/Carousel/Python1.jpg" width="300" height="300" alt=""/></a></li>
        </ul>
        <div class="arrow" id="arrow">
            <a href="javascript:;" class="prev" id="arrLeft"></a>
            <a href="javascript:;" class="next" id="arrRight"></a>
        </div>
    </div>
</div>
<!-- 旋转木马轮播ending -->
<?php require ('../ht/Common/db.php');?>

<!-- 主题内容starting -->
<div class="main">
    <?php
    require ('../ht/Common/db.php');
    //置顶sql---starting
    $sql = "SELECT * FROM blogs WHERE tid=7 AND top=1";
    $result = mysql_query($sql) or die ('查询失败!'.masql_error());
    $row = mysql_fetch_assoc($result);
    //置顶engding
    //javascript--sql--starting
    $sql1="SELECT * FROM blogs WHERE tid =3 and intro like '%模%'";
    $result1= mysql_query($sql1) or die ('查询失败!'.masql_error());
    $row1 = mysql_fetch_assoc($result1);
    //javascript--ending
    //眼前的苟且sql--starting
    $sql2="SELECT * FROM `blogs` WHERE tid=7 and title like '%眼前的苟且%'";
    $result2= mysql_query($sql2) or die ('查询失败!'.masql_error());
    $row2 = mysql_fetch_assoc($result2);
    //眼前的苟且ending
    //python3爬虫--sql-starting
    $sql3="SELECT * FROM `blogs` WHERE tid=2 and title like '%requests%'";
    $result3= mysql_query($sql3) or die ('查询失败!'.masql_error());
    $row3 = mysql_fetch_assoc($result3);
    //ending
    ?>
    <!-- 左边starting -->
    <div class="m_left">
        <div class="excerpt_first">

            <div class="content">
                <div class="theme">
                    置顶
                </div>
                <div class="title">
                    <?php
                    echo $row["title"];
                    ?>
                </div>
                <div class="focus">
                    <img src="../images/blog/<?php echo $row["pic"]?>" alt="<?php echo $row["pic"]?>" width="200" height="120">
                </div>
                <div class="note">
                    <?php
                    echo $row["intro"];
                    ?>
                </div>
                <ul class="detail">
                    <li>
                        <img src="../images/Font_Icon/心.png" alt="收藏量" title="收藏量">
                        <span><?php
                            echo $row["like"];
                            ?></span>
                    </li>
                    <li>
                        <img src="../images/Font_Icon/眼睛.png" alt="游览量" title="游览量">
                        <span><?php
                            echo $row["visited"];
                            ?></span>
                    </li>
                    <li>
                        <img src="../images/Font_Icon/时钟.png" alt="上传时间" title="上传时间">
                        <span><?php
                            echo $row["uploaddate"];
                            ?></span>
                    </li>
                    <li>
                        <img src="../images/Font_Icon/沐歌.png"  alt="上传人" title="上传人">
                        <span><?php
                            echo $row["uploadadmin"];
                            ?></span>
                    </li>
                </ul>

            </div>


        </div>
        <div class="excerpt">
            <div class="content">
                <div class="title">
                    <?php
                    echo $row1["title"];
                    ?>
                </div>
                <div class="focus">
                    <img src="../images/blog/<?php echo $row1["pic"]?>" alt="<?php echo $row1["pic"]?>" width="200" height="120">
                </div>
                <div class="note">
                    <?php
                    echo $row1["intro"];
                    ?>
                </div>
                <ul class="detail">
                    <li>
                        <img src="../images/Font_Icon/心.png" alt="收藏量" title="收藏量">
                        <span><?php
                            echo $row1["like"];
                            ?></span>
                    </li>
                    <li>
                        <img src="../images/Font_Icon/眼睛.png" alt="游览量" title="游览量">
                        <span><?php
                            echo $row1["visited"];
                            ?></span>
                    </li>
                    <li>
                        <img src="../images/Font_Icon/时钟.png" alt="上传时间" title="上传时间">
                        <span><?php
                            echo $row1["uploaddate"];
                            ?></span>
                    </li>
                    <li>
                        <img src="../images/Font_Icon/沐歌.png"  alt="上传人" title="上传人">
                        <span><?php
                            echo $row1["uploadadmin"];
                            ?></span>
                    </li>
                </ul>
            </div>
        </div>
        <div class="excerpt">
            <div class="content">
                <div class="title">
                    <?php
                    echo $row2["title"];
                    ?>
                </div>
                <div class="focus">
                    <img src="../images/blog/<?php echo $row2["pic"]?>" alt="<?php echo $row2["pic"]?>" width="200" height="120">
                </div>
                <div class="note">
                    <?php
                    echo $row2["intro"];
                    ?>
                </div>
                <ul class="detail">
                    <li>
                        <img src="../images/Font_Icon/心.png" alt="收藏量" title="收藏量">
                        <span><?php
                            echo $row2["like"];
                            ?></span>
                    </li>
                    <li>
                        <img src="../images/Font_Icon/眼睛.png" alt="游览量" title="游览量">
                        <span><?php
                            echo $row2["visited"];
                            ?></span>
                    </li>
                    <li>
                        <img src="../images/Font_Icon/时钟.png" alt="上传时间" title="上传时间">
                        <span><?php
                            echo $row2["uploaddate"];
                            ?></span>
                    </li>
                    <li>
                        <img src="../images/Font_Icon/沐歌.png"  alt="上传人" title="上传人">
                        <span><?php
                            echo $row2["uploadadmin"];
                            ?></span>
                    </li>
                </ul>
            </div>
        </div>
        <div class="excerpt">
            <div class="content">
                <div class="title">
                    <?php
                    echo $row3["title"];
                    ?>
                </div>
                <div class="focus">
                    <img src="../images/blog/<?php echo $row3["pic"]?>" alt="<?php echo $row3["pic"]?>" width="200" height="120">
                </div>
                <div class="note">
                    <?php
                    echo $row3["intro"];
                    ?>
                </div>
                <ul class="detail">
                    <li>
                        <img src="../images/Font_Icon/心.png" alt="收藏量" title="收藏量">
                        <span><?php
                            echo $row3["like"];
                            ?></span>
                    </li>
                    <li>
                        <img src="../images/Font_Icon/眼睛.png" alt="游览量" title="游览量">
                        <span><?php
                            echo $row3["visited"];
                            ?></span>
                    </li>
                    <li>
                        <img src="../images/Font_Icon/时钟.png" alt="上传时间" title="上传时间">
                        <span><?php
                            echo $row3["uploaddate"];
                            ?></span>
                    </li>
                    <li>
                        <img src="../images/Font_Icon/沐歌.png"  alt="上传人" title="上传人">
                        <span><?php
                            echo $row3["uploadadmin"];
                            ?></span>
                    </li>
                </ul>
            </div>
        </div>
    </div>
    <!-- 左边ending -->

    <!-- 右边starting -->
    <div class="m_right">
        <div class="icon">
            <ul>
                <li><img src="../images/Font_Icon/QQ.png" width="40" height="40" alt="QQ"></li>
                <li><img src="../images/Font_Icon/webchat.png" width="40" height="40" alt="微信"></li>
                <li><img src="../images/Font_Icon/weibo.png" width="40" height="40" alt="微博"></li>
                <li><img src="../images/Font_Icon/email.png" width="40" height="40" alt="邮箱"></li>

            </ul>
        </div>
        <div class="excerpt" id="slide-right">
            <!--轮播图starting-->
            <img src="../images/Carousel/1.jpg" width="330" height="130"/>
            <img src="../images/Carousel/2.jpg" width="330" height="130"/>
            <img src="../images/Carousel/3.jpg" width="330" height="130"/>
            <img src="../images/Carousel/4.jpg" width="330" height="130"/>
            <img src="../images/Carousel/5.jpg" width="330" height="130"/>
            <script type="text/javascript">
                var size = $('#slide-right img').size();
                var _index = size;
                var timer = null;
                $('#slide-right').append($('#slide-right img:eq(0)').clone());
                timer = setInterval(function () {
                    $('#slide-right img').eq(_index).fadeOut(800);
                    _index == 1 ? _index = size : _index--;
                    $('#slide-right img').eq(_index).fadeIn(800);
                }, 4000);
            </script>
            <!--轮播图ending-->
        </div>
        <div class="excerpt ex2">
            <h2 style="background-color: #FB4F4F;color: white"> 标签云集</h2>
            <button>div+css</button>
            <button>JavaScript</button>
            <button>PHP</button>
            <button>MySQL</button>
            <button>thinkPHP</button>
            <button>Python</button>
            <button>Git</button>
            <button>ajax</button>
            <button>jQuery</button>
        </div>
        <div class="excerpt">
            <img src="../images/blog/小橘子.jpg" width="330" height="130" alt="">
        </div>
        <div class="excerpt ex4">
            <h2 style="background-color: #FB4F4F;color: white"> 猜你喜欢</h2>
            <ul>
                <li>*祖国70周年大阅兵...</li>
                <li>*女排世界冠军...</li>
                <li>*即便你长得不帅，也能撩妹的技能...</li>
                <li>*更多...</li>
            </ul>
        </div>
        <div class="excerpt FriendlyLink">
            <h2 style="background-color: #FB4F4F;color: white"> 友情链接</h2>
            <ul class="ul_left">
                <li>百度SEO</li>
                <li>Git中文社区</li>
                <li>系统之家</li>
            </ul>
            <ul class="ul_right">
                <li>bilibili弹幕网</li>
                <li>w3c school官网</li>
                <li>网站模板</li>
            </ul>
        </div>
    </div>
    <!-- 右边ending -->
</div>

<!-- 主题内容starting -->

<!--footer starting-->
<?php
require('../qt/common/footer.php')
?>
<!--footer ending-->


</body>

</html>